CREATE PROCEDURE [dbo].[asi_CreateTempGL]
@accountKey uniqueidentifier,
@amount decimal(18,4),
@invoiceKey uniqueidentifier,
@paymentKey uniqueidentifier,
@productKey uniqueidentifier,
@finEntityKey uniqueidentifier,
@transDate datetime,
@journalType int,
@fiscalPeriod int,
@glEntryType nvarchar(50),
@description nvarchar(20),
@invoiceLineKey uniqueidentifier,
@defTermsKey uniqueidentifier,
@targetAcctKey uniqueidentifier,
@sequenceNumber int,
@originatingBatchNumber nvarchar(50),
@finalBatchNumber nvarchar(50),
@billToContactKey uniqueidentifier,
@journalEntryDescription nvarchar(50),
@invoiceLineNumber int
AS
DECLARE @salesHistoryKey uniqueidentifier
DECLARE @glTypeDistribution int
SET @glTypeDistribution = 1
INSERT #tmpTransLine(AccountKey, Amount, InvoiceKey, PaymentKey, Description, ProductKey,
FinEntityKey, TransDate, GLEntryType, JournalEntryTypeCode, FiscalPeriod,
InvoiceLineKey, DeferralTermsKey, TargetGLAccountKey, TransactionSequenceNumber, OriginatingBatchNumber,
FinalBatchNumber, BillToContactKey, JournalEntryDescription, InvoiceLineNumber)
VALUES (@accountKey, @amount, @invoiceKey, @paymentKey, @description , @productKey,
@finEntityKey, @transDate, @glEntryType, @journalType, @fiscalPeriod,
@invoiceLineKey, @defTermsKey, @targetAcctKey, @sequenceNumber,
@originatingBatchNumber, @finalBatchNumber, @billToContactKey, @journalEntryDescription, @invoiceLineNumber)

GO